home *** CD-ROM | disk | FTP | other *** search
/ Fritz: All Fritz / All Fritz.zip / All Fritz / FILES / BUSITION / DENTAS1.LZH / DENTL-A4.EXE / DENTIST.ACS / SOURCE.DOC < prev    next >
Text File  |  1992-03-27  |  7KB  |  175 lines
  1.                         SourceMatσ [TM▌ Custome≥ Filσ Menu
  2.                                  Overview:
  3.  
  4. Thi≤ optioε wil∞ creatσ record≤ iε thσ SourceMatσ [TM▌ Custome≥ Filσ forma⌠ ì
  5. anΣá theεá appenΣ theφ t∩ thσ SourceMatσ [TM▌ Custome≥ filσ iε thσá \SOURC┼ ì
  6. subdirector∙ anΣ drivσ oµ you≥ choice.
  7.  
  8. Optionally¼á yo⌡á caεá ß selec⌠ additiona∞ selectioε criterißá specifiπá t∩ ì
  9. SourceMatσ [TM].
  10.  
  11. Oncσá thσá ne≈ record≤ froφ thi≤ prograφ arσ appendeΣ int∩á thσá SourceMatσ ì
  12. [TM▌á Custome≥ file¼á yo⌡ mus⌠ reinde° thosσ file≤ withiε SourceMatσá [TM]«  ì
  13. T∩ d∩ this¼ brinτ u≡ thσ Maiε Men⌡ oµ Account≤ Receivable¼ versioε 2.0.
  14.  
  15. Iε Account≤ Receivable¼á pres≤ 'F8º t∩ g∩ t∩ Miscellaneous«á   Oncσ iεá thσ ì
  16. Miscellaneou≤á options¼á chosσá #│ t∩ 'Recove≥ Inde° Files.ºá  Afte≥á that¼ ì
  17. selec⌠ optioε ╢ t∩ reinde° thσ custome≥ file.
  18.  
  19.                                ==============
  20.                                |  OPTION 1: |
  21.                                ==============
  22.  
  23.                         1)  Output to Customer File
  24.  
  25.  
  26.   Fields created automatically in SourceMate [TM] file during conversion:
  27.            with fields from which data is drawn in PROSPECT.DBF   
  28.  
  29.  
  30.                           Structure of ARCUS.DBF
  31.  
  32. Structure for database: ARCUS        Corresponding fields in PROSPECT.DBF:
  33.  
  34.  
  35. Structure for database: ARCUS.dbf
  36. Number of data records:       0
  37. Date of last update   : 03/06/89              
  38. Field  Field Name  Type       Width       Dec
  39.     1  FCUSTNO     Character     10        <==== created from PROSPECT field
  40.     2  FCOMPANY    Character     35        <==== from PROSPECT field     
  41.     3  FADDR1      Character     35        <==== from ADDRESS1 field     
  42.     4  FADDR2      Character     35        <==== from ADDRESS2 field         
  43.     5  FCITY       Character     20        <==== from CITY field             
  44.     6  FSTATE      Character     15        <==== from STATE field            
  45.     7  FZIP        Character     10        <==== from ZIP field              
  46. *   8  FSADDR1     Character     35                                          
  47. *   9  FSADDR2     Character     35                 
  48. *  10  FSCITY      Character     20                                              
  49. *  11  FSSTATE     Character     15         
  50. *  12  FSZIP       Character     10        
  51.    13  FCONTACT    Character     30        <==== from FNAME + LNAME  
  52.    14  FTITLE      Character     10
  53.    15  FPHONE      Character     17        <==== from PHONE_1 field 
  54.    16  FPHONE2     Character     17
  55.    17  FTERM       Character     12è   18  FARACC      Character     14
  56.    19  FCCLASS     Character      1
  57.    20  FSALESPN    Character      5
  58.    21  FTERR       Character      2
  59.    22  FINDUSTRY   Character      2
  60.    23  FTAXCODE1   Character      2
  61.    24  FTAXCODE2   Character      2
  62.    25  FPAYTYPE    Character      1
  63.    26  FPRICECD    Numeric        2
  64.    27  FDISRATE    Numeric        5      2
  65.    28  FTAXRATE1   Numeric        6      3
  66.    29  FTAXRATE2   Numeric        6      3
  67.    30  FCRLIMIT    Numeric       14      2
  68.    31  FOPENCR     Numeric       14      2
  69.    32  FBAL        Numeric       14      2
  70.    33  FCURORDER   Numeric       14      2
  71.    34  FATDSAMT    Numeric       14      2
  72.    35  FYTDSAMT    Numeric       14      2
  73.    36  FMTDSAMT    Numeric       14      2
  74.    37  FQTDSAMT1   Numeric       14      2
  75.    38  FQTDSAMT2   Numeric       14      2
  76.    39  FLPAMT      Numeric       14      2
  77.    40  FLPDATE     Date           8
  78.    41  FNEWDATE    Date           8
  79.    42  FACTIVE     Logical        1
  80.    43  FDISCNT     Logical        1
  81.    44  FFINCHG     Logical        1
  82.    45  FMSHIP      Logical        1
  83.    46  FLOCKED     Logical        1
  84.    47  FRESALENO   Character     16
  85.    48  FVSNO       Character     22
  86.    49  FVSNAME     Character     30
  87.    50  FVSEXPDATE  Character      5
  88.    51  FMCNO       Character     22
  89.    52  FMCNAME     Character     30
  90.    53  FMCEXPDATE  Character      5
  91.    54  FAENO       Character     22
  92.    55  FAENAME     Character     30
  93.    56  FAEEXPDATE  Character      5
  94.    57  FCCNO       Character     22
  95.    58  FCCNAME     Character     30
  96.    59  FCCEXPDATE  Character      5
  97. ** Total **                     815
  98.  
  99. * Note that all 'Ship to' and 'Bill to' addresses are assumed to be the same.
  100.  
  101.  
  102.  
  103.  
  104.       Logic behind creation of FCUSTNO field in SourceMate [TM] file:
  105.                              two step process
  106.  
  107.  
  108. Thσá prograφ firs⌠ look≤ t∩ seσ iµ yo⌡ havσ entereΣ thi≤ phrasσ int∩ eithe≥ ì
  109. COMMENT▒ o≥ COMMENT2║á  "CUSTNO='«á  Iµ thi≤ codσ i≤ present¼á theε thσ teε ìècharacter≤ followinτ "CUSTNO=ó arσ placeΣ int∩ thσ correspondinτ SourceMatσ ì
  110. [TM▌ record«  
  111.      
  112. Secondly¼á thσá prograφá wil∞ creatσ ß fou≥ characte≥ codσ iε FCUSTN╧á tha⌠ ì
  113. adhere≤ t∩ thσ followinτ logic:
  114.  
  115. 1)  The fourth character will be a '1'
  116. 2⌐á Thσ firs⌠ threσ character≤ wil∞ bσ takeε froφ thσ firs⌠ lette≥ oµá eacΦ ì
  117. namσ froφ thσ compan∙ namσ o≥ PROSPEC╘ field.
  118. 3)  The following articles are dropped from the company name during step 2:
  119.  
  120.                        A AN IN OR & THE OF FOR WITH
  121.  
  122. 4⌐  Iµ thσ resultinτ word≤ iε thσ compan∙ namσ numbe≥ les≤ thaε 3¼ theε thσ ì
  123. remaininτ character≤ arσ takeε a≤ needeΣ froφ thσ las⌠ completσ worΣ iε thσ ì
  124. compan∙ name« 
  125.  
  126.                                  Examples:
  127.                           [taken from test data]
  128.        
  129.     FCUSTNO     Company name:
  130.  
  131.          ATS1   Accounting & Tax Service           
  132.          ADD1   Addmaster/Marchant                 
  133.          FDS1   Fourcolor Data Systems             
  134.          LLE1   Lolir Lectronics                   
  135.          MDC1   Micro Distribution Center          
  136.          NAI1   North American Investment Corp.    
  137.          PBO1   P.O. BOX                           
  138.          REV1   Rex Evilsizor                      
  139.          SEL1   Sabet Electronics                  
  140.          TCP1   Texas Commerce Plumbing            
  141.  
  142.  
  143.                                ==============
  144.                                |  OPTION 2: |
  145.                                ==============
  146.  
  147.           2) Additional selection criteria specific to SourceMate [TM]:
  148.  
  149.  
  150. A⌠ thi≤ menu¼á yo⌡ caε ente≥ value≤ whicΦ wil∞ bσ placeΣ iε al∞ record≤ no≈ ì
  151. beinτá outputteΣá t∩ thσ SourceMatσ [TM▌ custome≥ file«á  Thesσ arσá field≤ ì
  152. ove≥á anΣ beyonΣ thσ minima∞ field≤ beinτ createΣ iε eacΦá SourceMatσá [TM▌ ì
  153. custome≥ record.
  154.  
  155. These optional fields are:
  156.  
  157. FTERM
  158. FARACC
  159. FCCLASS
  160. FSALESPN
  161. FTERR
  162. FINDUSTRY
  163. FTAXCODE1èFTAXCODE2
  164. FPAYTYPE
  165. FDISRATE
  166. FTAXRATE1
  167. FTAXRATE2
  168. FCRLIMIT
  169. FCURORDER
  170. FDISCNT
  171. FFINCHG
  172.  
  173.  
  174.  
  175.